
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

--
-- 增加二个用户分组
--

REPLACE INTO `fa_user_group` (`name`,`rules`,`createtime`,`updatetime`,`status`) VALUES
('买家','1,3,5,6,7,8,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150',1545204410,1545204410,'normal'),
('卖家','1,3,5,6,7,8,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234',1545204431,1545204431,'normal');

--
-- Data for table "fa_user"
-- 默认admin为店铺1（自营）管理员
-- 新增8个测试帐号seller2-9为店铺2-9的管理者，如果user表中seller2-9的id不为2-9，请在mall_shop_shop表中修改user_id字段值，以便关联匹配。
-- 新增2个测试帐号buyer1-2为买家。
-- 默认密码为123456
--
REPLACE INTO `fa_user` (`group_id`,`username`,`nickname`,`password`,`salt`,`email`,`mobile`,`avatar`,`level`,`gender`,`birthday`,`bio`,`money`,`score`,`successions`,`maxsuccessions`,`prevtime`,`logintime`,`loginip`,`loginfailure`,`joinip`,`jointime`,`createtime`,`updatetime`,`token`,`status`,`verification`) VALUES
(3,'seller2','seller2','10d9832cff47d53b528c21c6cd006e2a','qT6ACm','seller2@163.com','19999999992','',1,0,NULL,'',1000.00,0,1,1,1555305892,1555488200,'127.0.0.1',0,'127.0.0.1',1545554770,1545554770,1555488200,'','normal',''),
(3,'seller3','seller3','10d9832cff47d53b528c21c6cd006e2a','qT6ACm','seller3@163.com','19999999993','',1,0,NULL,'',1000.00,0,1,1,1557743140,1558223879,'127.0.0.1',0,'127.0.0.1',1545554770,1545554770,1558223879,'','normal',''),
(3,'seller4','seller4','10d9832cff47d53b528c21c6cd006e2a','qT6ACm','seller4@163.com','19999999994','',1,0,NULL,'',1000.00,0,1,1,1555305892,1555488200,'127.0.0.1',0,'127.0.0.1',1545554770,1545554770,1555488200,'','normal',''),
(3,'seller5','seller5','10d9832cff47d53b528c21c6cd006e2a','qT6ACm','seller5@163.com','19999999995','',1,0,NULL,'',1000.00,0,1,1,1555305892,1555488200,'127.0.0.1',0,'127.0.0.1',1545554770,1545554770,1555488200,'','normal',''),
(3,'seller6','seller6','10d9832cff47d53b528c21c6cd006e2a','qT6ACm','seller6@163.com','19999999996','',1,0,NULL,'',1000.00,0,1,1,1555488200,1557730605,'127.0.0.1',0,'127.0.0.1',1545554770,1545554770,1557730605,'','normal',''),
(3,'seller7','seller7','10d9832cff47d53b528c21c6cd006e2a','qT6ACm','seller7@163.com','19999999997','',1,0,NULL,'',1000.00,0,1,1,1555488200,1557743076,'127.0.0.1',0,'127.0.0.1',1545554770,1545554770,1557743076,'','normal',''),
(3,'seller8','seller8','10d9832cff47d53b528c21c6cd006e2a','qT6ACm','seller8@163.com','19999999998','',1,0,NULL,'',1000.00,0,1,1,1555305892,1555488200,'127.0.0.1',0,'127.0.0.1',1545554770,1545554770,1555488200,'','normal',''),
(3,'seller9','seller9','10d9832cff47d53b528c21c6cd006e2a','qT6ACm','seller9@163.com','19999999999','',1,0,NULL,'',1000.00,0,1,1,1557742371,1558227385,'127.0.0.1',0,'127.0.0.1',1545554770,1545554770,1558227385,'','normal',''),
(2,'buyer1','buyer1','10d9832cff47d53b528c21c6cd006e2a','qT6ACm','buyer1@163.com','19999999910','',1,0,NULL,'',1000.00,0,1,1,1557741321,1557742421,'127.0.0.1',0,'127.0.0.1',1545554770,1545554770,1557742421,'','normal',''),
(2,'buyer2','buyer2','10d9832cff47d53b528c21c6cd006e2a','qT6ACm','buyer2@163.com','19999999911','',1,0,NULL,'',1000.00,0,1,1,1555305892,1555488200,'127.0.0.1',0,'127.0.0.1',1545554770,1545554770,1555488200,'','normal','');

--
-- 将"fa_mall_user_extra"表与user表中的帐户同步
--
BEGIN;
INSERT INTO `fa_mall_user_extra` (`user_id`) SELECT id AS user_id FROM `fa_user` WHERE id NOT IN (SELECT `user_id` FROM `fa_mall_user_extra`);
COMMIT;

COMMIT;